2014-09-02 - 10735.1900 - Spec - Estimate - Japan data in Scorecard #CrystalReportDevelopment
SPECIFICATIONS
10735.1900 - Spec - Estimate - Japan data in Scorecard
Purpose
Need to understand the level of effort involved in updating the Scorecard reports to reference SAP for Japan data(when that data is available). Below are a list of items that need to be considered in the estimate:
1. Mapping report fields to SAP.
2. Maintaining Historic data.
3. Do previous year fields need to be re mapped to a static version of the file?
4. File placement and maintenance.
5. What is the process and timing for changing these fields to SAP.
6. Report formatting.
Admin Info
Purpose
|
Estimate - Japan data in Scorecard
|
Requested By
|
Mark Grzechowiak
|
Spec Created By
|
Praveen Guntuka
|
Spec Created Date
|
09/03/2014
|
Spec QA by
|
Uday Kumar P
|
Objects
|
SA110 - Corporate Scorecard
SA115 - Corporate Scorecard By Regions
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
02
|
2
|
Documentation
|
08
|
3
|
Development/Config
|
48
|
4
|
Unit test in DEV
|
08
|
5
|
Unit test in QUA
|
06
|
6
|
Formatting Changes
|
08
|
|
TOTAL
|
80
|
References
Prior Tickets
None
Documents
None
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
NEC is adding Japan data to SAP and part of that project is to pull Japan data into the Scorecard reports from SAP as opposed to the file that is currently in use.
In Scope:
1. Need to eliminate the sheets from the report and need to use the SAP source for Japan data.
2. Need to use Sheets in reports to show historic data.
Out of Scope:
None
Solution Summary
1. Need to fetch Japan data into the Scorecard report from SAP as opposed to the file that is currently in use.
2. Need to use the sheet in the report to show historic data in the report.
3. Need to use the sheet until such time where all data can be accurately pulled from SAP source.
Test Plan
Test ID
|
Test Scenario
|
Expected Results
|
1
|
Report Format.
|
Should be as per NEC crystal standard checklist.
|
2
|
Execute Crystal Report in Crystal Designer tool after changes.
|
Report should execute successfully in Crystal Designer tool.
|
3
|
Schedule the Report in NEC BI Launch Pad.
|
Report should execute successfully in NEC BI Launch Pad.
|
4
|
Need to check the formatting of the database fields.
|
Formatting should be as per production reports.
|
5
|
Need to compare the report results with production reports.
|
Should match all the values.
|
Solution Details
1. Need to fetch Japan data into the Scorecard reports(SA110 and SA115 Crystal Reports) from SAP as opposed to the file that is currently in use.
2. Need to use the Japan sheet in the report to show Japan data from Last Year Month-to-Date and Year-to-Date values.
3. Need to use the sheet until such time where all data can be accurately pulled from SAP source.
4. Need to use Static/Regular Japan sheet for Last Year MTD and YTD values in the scorecard report.
5. Need to remove the fields from the report and place the respective SAP source fields in the report design to show the Japan data in respective sections.
6. Need to format the report to fit the data in pagewise.
7. Need to change the restrictions and formulas that are using Japan sheet fields.
8. Need to remove the unused sheets from the reports.
Issues
None